SyCampusDetails_Proxy

EntityType | Independent
Logical Entity Name | SyCampusDetails_Proxy
Default Table Name | SyCampusDetails_Proxy
Logical Only | NO
Owner | dbo
Definition |
Note |

SyCampusDetails_Proxy Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
SyCampusDetails_ProxyID |  | INTEGER | NO |
RecordID |  | INTEGER | NO |
OldCampusPresidentID |  | INTEGER | YES |
NewCampusPresidentID |  | INTEGER | YES |
OldCampusDirectorofAdmissionsID |  | INTEGER | YES |
NewCampusDirectorofAdmissionsID |  | INTEGER | YES |
OldCampusDirectorofFAID |  | INTEGER | YES |
NewCampusDirectorofFAID |  | INTEGER | YES |
OldCampusDirectorofEducationID |  | INTEGER | YES |
NewCampusDirectorofEducationID |  | INTEGER | YES |
OldCampusBusinessOfficeID |  | INTEGER | YES |
NewCampusBusinessOfficeID |  | INTEGER | YES |
OldCampusDirectorofCareerID |  | INTEGER | YES |
NewCampusDirectorofCareerID |  | INTEGER | YES |
OldDNCOverrideDocID |  | INTEGER | YES |
NewDNCOverrideDocID |  | INTEGER | YES |
Old1098TReportMethod |  | CHAR(1) | YES |
New1098TReportMethod |  | CHAR(1) | YES |
Old1098TElectronically |  | BIT | YES |
New1098TElectronically |  | BIT | YES |
Old1098TServicer |  | BIT | YES |
New1098TServicer |  | BIT | YES |
Old1098TPath |  | VARCHAR(100) | YES |
New1098TPath |  | VARCHAR(100) | YES |
OldEntranceInterviewDocID |  | INTEGER | YES |
NewEntranceInterviewDocID |  | INTEGER | YES |
OldAllowEditRT4Amounts |  | BIT | YES |
NewAllowEditRT4Amounts |  | BIT | YES |
OldRT4EditNumDaysPrior |  | INTEGER | YES |
NewRT4EditNumDaysPrior |  | INTEGER | YES |
OldExpectedRefundOption |  | INTEGER | YES |
NewExpectedRefundOption |  | INTEGER | YES |
OldExpectedRefundLDADays |  | INTEGER | YES |
NewExpectedRefundLDADays |  | INTEGER | YES |
OldExpectedRefundDropDateDays |  | INTEGER | YES |
NewExpectedRefundDropDateDays |  | INTEGER | YES |
OldCommonlinePath |  | VARCHAR(255) | YES |
NewCommonlinePath |  | VARCHAR(255) | YES |
OldT4IncludeStudentInRefund |  | BIT | YES |
NewT4IncludeStudentInRefund |  | BIT | YES |
OldT4IncludeStudentInRefundOverride |  | BIT | YES |
NEwT4IncludeStudentInRefundOverride |  | BIT | YES |
OldRunSapAfterDrop |  | CHAR(1) | YES |
NewRunSapAfterDrop |  | CHAR(1) | YES |
OldAutoAdjustChargesAddDropPeriod |  | BIT | YES |
NewAutoAdjustChargesAddDropPeriod |  | BIT | YES |
OldMaxDaysPastGradDate |  | INTEGER | YES |
NewMaxDaysPastGradDate |  | INTEGER | YES |
OldRestrictPaymentDisbDates |  | BIT | YES |
NewRestrictPaymentDisbDates |  | BIT | YES |
OldDefaultEnrollmentOnLedger |  | VARCHAR(2) | YES |
NewDefaultEnrollmentOnLedger |  | VARCHAR(2) | YES |
OldUseAutoStipends |  | BIT | YES |
NewUseAutoStipends |  | BIT | YES |
OldAuthorizationPreventsAutoStipends |  | BIT | YES |
NewAuthorizationPreventsAutoStipends |  | BIT | YES |
OldCreditBalanceEvalType |  | VARCHAR(2) | YES |
NewCreditBalanceEvalType |  | VARCHAR(2) | YES |
OldCreditBalanceEvalTimeFrame |  | VARCHAR(2) | YES |
NewCreditBalanceEvalTimeFrame |  | VARCHAR(2) | YES |
OldAllowMultiInquiry |  | BIT | YES |
NewAllowMultiInquiry |  | BIT | YES |
OldInquiryDaysBasisDateCode |  | CHAR(1) | YES |
NewInquiryDaysBasisDateCode |  | CHAR(1) | YES |
OldInquiryDaysSinceBasisDate |  | INTEGER | YES |
NewInquiryDaysSinceBasisDate |  | INTEGER | YES |
Old1098TPhone |  | VARCHAR(16) | YES |
New1098TPhone |  | VARCHAR(16) | YES |
Old1098TPhoneExt |  | VARCHAR(5) | YES |
New1098TPhoneExt |  | VARCHAR(5) | YES |
Old1098TUseCampusInfo |  | BIT | YES |
New1098TUseCampusInfo |  | BIT | YES |
OldDuplicateEmpCheckSyCampusGrpID |  | INTEGER | YES |
NewDuplicateEmpCheckSyCampusGrpID |  | INTEGER | YES |
OldCmFERPAID |  | INTEGER | YES |
NewCmFERPAID |  | INTEGER | YES |
OldAdTranscriptConfigID |  | INTEGER | YES |
NewAdTranscriptConfigID |  | INTEGER | YES |
OldTranscriptLogoFilePath |  | VARCHAR(2000) | YES |
NewTranscriptLogoFilePath |  | VARCHAR(2000) | YES |
OldPostIndMidTermGrade |  | BIT | YES |
NewPostIndMidTermGrade |  | BIT | YES |
OldDaysAddLDADeterminationDate |  | INTEGER | YES |
NewDaysAddLDADeterminationDate |  | INTEGER | YES |
OldHsEmailTemplateID |  | INTEGER | YES |
NewHsEmailTemplateID |  | INTEGER | YES |
OldHsLetterTemplateID |  | INTEGER | YES |
NewHsLetterTemplateID |  | INTEGER | YES |
OldEnablingUpdateStudentToActiveLOA_SPN |  | BIT | YES |
NewEnablingUpdateStudentToActiveLOA_SPN |  | BIT | YES |
OldSaCourseRefundPolicyID |  | INTEGER | YES |
NewSaCourseRefundPolicyID |  | INTEGER | YES |
OldT4_DaysToAddToDropDate |  | INTEGER | YES |
NewT4_DaysToAddToDropDate |  | INTEGER | YES |
OldT4IncludeStudentPLUSInRefund |  | BIT | YES |
NewT4IncludeStudentPLUSInRefund |  | BIT | YES |
OldT4IncludeStudentStaffordInRefund |  | BIT | YES |
NewT4IncludeStudentStaffordInRefund |  | BIT | YES |
OldPromissoryNoteReport |  | VARCHAR(255) | YES |
NewPromissoryNoteReport |  | VARCHAR(255) | YES |
OldApproveAwardVerified |  | BIT | YES |
NewApproveAwardVerified |  | BIT | YES |
OldAddStudentsToSSCR |  | BIT | YES |
NewAddStudentsToSSCR |  | BIT | YES |
OldCheckInFieldOfStudy |  | BIT | YES |
NewCheckInFieldOfStudy |  | BIT | YES |
OldAuthorOnlyEditAYComments |  | BIT | YES |
NewAuthorOnlyEditAYComments |  | BIT | YES |
OldUseTerminAYDates |  | BIT | YES |
NewUseTerminAYDates |  | BIT | YES |
OldSSCRWithdrawalStatusDate |  | VARCHAR(1) | YES |
NewSSCRWithdrawalStatusDate |  | VARCHAR(1) | YES |
OldEnableCatalogYear |  | BIT | YES |
NewEnableCatalogYear |  | BIT | YES |
OldAllowAutoAddCourseSection |  | BIT | YES |
NewAllowAutoAddCourseSection |  | BIT | YES |
OldAllowOverlappingTerm |  | BIT | YES |
NewAllowOverlappingTerm |  | BIT | YES |
OldRemittanceAddress |  | VARCHAR(255) | YES |
NewRemittanceAddress |  | VARCHAR(255) | YES |
OldRemittanceCity |  | VARCHAR(25) | YES |
NewRemittanceCity |  | VARCHAR(25) | YES |
OldRemittanceState |  | VARCHAR(2) | YES |
NewRemittanceState |  | VARCHAR(2) | YES |
OldRemittanceZip |  | VARCHAR(10) | YES |
NewRemittanceZip |  | VARCHAR(10) | YES |
OldRemittanceSyCountryID |  | INTEGER | YES |
NewRemittanceSyCountryID |  | INTEGER | YES |
OldRequiredToTakeAttendance |  | BIT | YES |
NewRequiredToTakeAttendance |  | BIT | YES |
OldCalculateInProgressGrade |  | BIT | YES |
NewCalculateInProgressGrade |  | BIT | YES |
OldDisplayOverallCumGPA |  | BIT | YES |
NewDisplayOverallCumGPA |  | BIT | YES |
OldPortalCreatesNoApplicantRecord |  | BIT | YES |
NewPortalCreatesNoApplicantRecord |  | BIT | YES |
OldGradeLevelPreReq |  | BIT | YES |
NewGradeLevelPreReq |  | BIT | YES |
OldVoidRefundOrStipend |  | CHAR(1) | YES |
NewVoidRefundOrStipend |  | CHAR(1) | YES |
OldSapCalcDaysAfterTermEnd |  | INTEGER | YES |
NewSapCalcDaysAfterTermEnd |  | INTEGER | YES |
OldSapAutomatedReviewEnable |  | BIT | YES |
NewSapAutomatedReviewEnable |  | BIT | YES |
OldAssociateCompleteDropCourses |  | BIT | YES |
NewAssociateCompleteDropCourses |  | BIT | YES |
OldAllowReimportCommonLineResponseFile |  | BIT | YES |
NewAllowReimportCommonLineResponseFile |  | BIT | YES |
OldCompareContactHrsWithClsSched |  | BIT | YES |
NewCompareContactHrsWithClsSched |  | BIT | YES |
OldAutomateRevenueRec |  | BIT | YES |
NewAutomateRevenueRec |  | BIT | YES |
OldAutomateReleaseToGL |  | BIT | YES |
NewAutomateReleaseToGL |  | BIT | YES |
OldDaysToPostRevenue |  | INTEGER | YES |
NewDaysToPostRevenue |  | INTEGER | YES |
OldAllowRefundCalcForReEntry |  | BIT | YES |
NewAllowRefundCalcForReEntry |  | BIT | YES |
UserID |  | INTEGER | NO |
DateAdded |  | DATETIME | NO |
OldRetakeFeeWaiveIfPassGrade |  | BIT | YES |
NewRetakeFeeWaiveIfPassGrade |  | BIT | YES |
OldRetakeFeeWaiveIfFailGrade |  | BIT | YES |
NewRetakeFeeWaiveIfFailGrade |  | BIT | YES |
OldRetakeFeeWaiveIfAfterCourseStart |  | BIT | YES |
NewRetakeFeeWaiveIfAfterCourseStart |  | BIT | YES |
OldRetakeFeeCourseStartAfterNumDays |  | INTEGER | YES |
NewRetakeFeeCourseStartAfterNumDays |  | INTEGER | YES |
OldEnforceLDW |  | BIT | YES |
NewEnforceLDW |  | BIT | YES |
OldLDWPercentage |  | SMALLINT | YES |
NewLDWPercentage |  | SMALLINT | YES |
OldAddDropForDropStatus |  | BIT | YES |
NewAddDropForDropStatus |  | BIT | YES |
OldLDWWeekEndDay |  | SMALLINT | YES |
NewLDWWeekEndDay |  | SMALLINT | YES |
OldLDWDay |  | CHAR(1) | YES |
NewLDWDay |  | CHAR(1) | YES |
OldLDWWeekDefinition |  | CHAR(1) | YES |
NewLDWWeekDefinition |  | CHAR(1) | YES |
OldEvaluateAllCriteria |  | BIT | YES |
NewEvaluateAllCriteria |  | BIT | YES |
OldEvaluateJobTitle |  | BIT | YES |
NewEvaluateJobTitle |  | BIT | YES |
OldEvaluateJobLocation |  | BIT | YES |
NewEvaluateJobLocation |  | BIT | YES |
OldIsAthleticAssociationMember |  | BIT | YES |
NewIsAthleticAssociationMember |  | BIT | YES |
OldAthleticAssociationCode |  | VARCHAR(10) | YES |
NewAthleticAssociationCode |  | VARCHAR(10) | YES |
OldAthleteEligibilityYears |  | TINYINT | YES |
NewAthleteEligibilityYears |  | TINYINT | YES |
NewHousingContractReport |  | VARCHAR(100) | YES |
OldHousingContractReport |  | VARCHAR(100) | YES |
NewIsContractPrintingEnable |  | BIT | YES |
OldIsContractPrintingEnable |  | BIT | YES |
NewExpireLeaseOnEndDate |  | BIT | YES |
OldExpireLeaseOnEndDate |  | BIT | YES |
NewExpireIfSubsiquentLeaseBilled |  | BIT | YES |
OldExpireIfSubsiquentLeaseBilled |  | BIT | YES |
NewDoNotExpireLastLease |  | BIT | YES |
OldDoNotExpireLastLease |  | BIT | YES |
NewUpdLeaseOnEnrollmentTransfer |  | BIT | YES |
OldUpdLeaseOnEnrollmentTransfer |  | BIT | YES |
OldAutoUnregisterDueToGrade |  | BIT | YES |
NewAutoUnregisterDueToGrade |  | BIT | YES |
OldAutoUnregisterDueToOtherReason |  | BIT | YES |
NewAutoUnregisterDueToOtherReason |  | BIT | YES |
OldAutoUnregisterReasonID |  | INTEGER | YES |
NewAutoUnregisterReasonID |  | INTEGER | YES |
OldCourseStatusForAutoUnregister |  | VARCHAR(10) | YES |
NewCourseStatusForAutoUnregister |  | VARCHAR(10) | YES |
OldNumDaysPastExpDeadlineOverride |  | INTEGER | YES |
NewNumDaysPastExpDeadlineOverride |  | INTEGER | YES |
OldNumDaysExpDeadline |  | INTEGER | YES |
NewNumDaysExpDeadline |  | INTEGER | YES |
OldAllowFSAfundsPriorPeriodCharges |  | BIT | YES |
NewAllowFSAfundsPriorPeriodCharges |  | BIT | YES |
OldCreditBalanceEvaluationScheduling |  | CHAR(2) | YES |
NewCreditBalanceEvaluationScheduling |  | CHAR(2) | YES |
OldIncludeTitleIVEvaluation |  | BIT | YES |
NewIncludeTitleIVEvaluation |  | BIT | YES |
OldDisbCancelNotification |  | BIT | YES |
OldDisbCancelCmTemplateID |  | INTEGER | YES |
OldDisbToReExpectCmTemplateID |  | INTEGER | YES |
OldNotifyToSyStaffID |  | INTEGER | YES |
NewDisbCancelNotification |  | BIT | YES |
NewDisbCancelCmTemplateID |  | INTEGER | YES |
NewDisbToReExpectCmTemplateID |  | INTEGER | YES |
NewNotifyToSyStaffID |  | INTEGER | YES |
OldIsForeignSchool |  | BIT | YES |
NewIsForeignSchool |  | BIT | YES |
OldSapCalcDaysAfterPaymentPeriodEnd |  | INTEGER | YES |
NewSapCalcDaysAfterPaymentPeriodEnd |  | INTEGER | YES |
OldRestrictWaitListing |  | BIT | YES |
NewRestrictWaitListing |  | BIT | YES |
OldAddDropForCurrentOrLOACourses |  | BIT | YES |
NewAddDropForCurrentOrLOACourses |  | BIT | YES |
OldISIROverridesHousingCode |  | BIT | YES |
NewISIROverridesHousingCode |  | BIT | YES |
NewCustomAttendanceMessage |  | BIT | YES |
OldCustomAttendanceMessage |  | BIT | YES |
NewAttendanceMessage |  | VARCHAR(2000) | YES |
OldAttendanceMessage |  | VARCHAR(2000) | YES |
OldUseOverlapLoanPeriod |  | BIT | YES |
NewUseOverlapLoanPeriod |  | BIT | YES |
OldCreditConvert |  | INTEGER | YES |
NewCreditConvert |  | INTEGER | YES |
OldHourConvert |  | INTEGER | YES |
NewHourConvert |  | INTEGER | YES |
OldPreventAutoMatch |  | BIT | YES |
NewPreventAutoMatch |  | BIT | YES |
OldAssociateFulfillDPA |  | BIT | YES |
NewAssociateFulfillDPA |  | BIT | YES |
OldEnableLOABoundariesCheck |  | BIT | YES |
NewEnableLOABoundariesCheck |  | BIT | YES |
OldUseFundSourceOrder |  | BIT | YES |
NewUseFundSourceOrder |  | BIT | YES |
OldAutoStipendExcludeStatuses |  | VARCHAR(2048) | YES |
NewAutoStipendExcludeStatuses |  | VARCHAR(2048) | YES |
OldAllowZeroOutExtraAYLP |  | BIT | YES |
NewAllowZeroOutExtraAYLP |  | BIT | YES |
OldDoNotAdjFullyDisbAYLP |  | BIT | YES |
NewDoNotAdjFullyDisbAYLP |  | BIT | YES |
OldIncludeDebitBalFromPrior |  | BIT | YES |
NewIncludeDebitBalFromPrior |  | BIT | YES |
OldAYLPnotification |  | BIT | YES |
NewAYLPnotification |  | BIT | YES |
OldNotifyAYLPToSyStaffID |  | INTEGER | YES |
NewNotifyAYLPToSyStaffID |  | INTEGER | YES |
OldAllowStudentAttestation |  | BIT | YES |
NewAllowStudentAttestation |  | BIT | YES |
OldMultipleDisbRuleEnabled |  | BIT | YES |
NewMultipleDisbRuleEnabled |  | BIT | YES |
OldEnableMultiDisbRecalc |  | BIT | YES |
NewEnableMultiDisbRecalc |  | BIT | YES |

SyCampusDetails_Proxy Keys

Key Name | Key Type | Keys
PK_SyCampusDetails_Proxy_SyCampusDetails_ProxyID | PrimaryKey | SyCampusDetails_ProxyID

SyCampusDetails_Proxy Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

SyCampusDetails_Proxy Check Constraints

Check Constraint Name | CheckConstraint

SyCampusDetails_Proxy Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SyCampusDetails_Proxy | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyCampusDetails_Proxy | NO |  |  |

SyCampusDetails_Proxy Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

SyCampusDetails_Proxy Data Movement Rules

Name | Type | Rule Text/Value